SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbCongresosSeminarios
AS
SELECT     dbo.tb_CongresosSeminarios.Agente, dbo.vwrGruposdeIncumbencias.Descripcion AS GrupodeIncumbencias, 
                      dbo.vwrTipoEntidadCapacitadora.Descripcion AS TipoEntidad, dbo.tb_CongresosSeminarios.FechaDelEvento
FROM         dbo.tb_CongresosSeminarios LEFT OUTER JOIN
                      dbo.vwrTipoEntidadCapacitadora ON dbo.tb_CongresosSeminarios.TipoEntidad = dbo.vwrTipoEntidadCapacitadora.ID LEFT OUTER JOIN
                      dbo.vwrGruposdeIncumbencias ON dbo.tb_CongresosSeminarios.GrupoIncumbencias = dbo.vwrGruposdeIncumbencias.id
GO
GRANT SELECT ON  [dbo].[vwbCongresosSeminarios] TO [Juntas]
GRANT SELECT ON  [dbo].[vwbCongresosSeminarios] TO [MCEEjecutivo]
GRANT SELECT ON  [dbo].[vwbCongresosSeminarios] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vwbCongresosSeminarios] TO [SoloVer]
GO
